SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 118300 LIMIT 1 [ RunTime:0.000561s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 118300 [ RunTime:0.001843s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511959,417900,802396,607187,256968,45284,688943,883878,907936,742312,114823,1013568,451743,215439,364171,394649,843749,519182,499120,392279,955103,210240,256729,904941,441805,861728,769804,201139,251986,227665,719135,793174,497602,506004,631537,561787,102570,1008342,431505,639724,887482,984935,759439,437938,263489,725195,1010323,834432,373805,256364,835476,637683,111421,358076,459029,103014,631620,939607,312751,85725) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 118300 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000435s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 118300 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000638s ]