SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003721s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545905 LIMIT 1 [ RunTime:0.004976s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545905 [ RunTime:0.007529s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (656210,108305,525372,1002565,650575,285073,388943,405556,90475,220117,970378,352686,350501,874042,404788,453396,1035353,191137,324662,314761,508893,852320,774380,376167,380917,885944,949769,94720,197438,86049,89299,34800,969810,447577,79389,1038570,141904,134866,69056,4762,27916,237969,902516,633584,731895,1044602,717379,757671,41943,812650,248903,249939,607051,755116,874551,840309,746596,229224,963369,102868) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001121s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545905 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545905 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001311s ]