SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 40009 LIMIT 1 [ RunTime:0.000358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 40009 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (212713,975375,168927,767439,240252,125201,55284,89569,960030,723410,796675,111790,739295,120381,1047313,103764,342899,1040538,526012,5143,183749,889056,629037,1042142,122853,13883,29478,1046976,978597,898548,581322,49610,319664,383896,1002273,578060,969685,54444,40800,769270,531727,174072,883541,755953,360575,825903,349514,885688,561963,735074,633712,548584,462826,920777,974021,969986,396886,738406,199143,936227) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004300s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 40009 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 40009 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000589s ]