SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 45081 LIMIT 1 [ RunTime:0.000480s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 45081 [ RunTime:0.001785s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (572127,824965,942962,804790,102701,685537,399733,62393,1007511,510734,537775,748956,824414,504341,170842,879623,286913,937685,343132,784028,426825,235525,626265,705963,760502,567411,344144,322094,487680,677147,834355,969610,194786,68694,285931,464893,223470,257436,320454,234535,911259,91638,647426,750092,47133,694750,424363,151896,1010149,355178,586875,349712,87553,831218,441275,973784,650407,505803,112045,719550) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 45081 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000388s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 45081 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000682s ]