SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001285s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1006078 LIMIT 1 [ RunTime:0.000641s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1006078 [ RunTime:0.002234s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365396,431439,498878,645964,285813,926908,1026783,141942,36197,558746,154493,1004669,531549,292912,554765,643084,999784,667818,778589,50779,478920,365910,609631,179026,329155,358810,463603,212671,1015108,785812,291321,686930,104978,249549,581620,84696,558889,218494,1037928,136792,28777,133620,851350,235387,945853,621698,743011,5821,602343,383245,695102,478509,494655,253823,1018021,988968,772121,852882,849334,51039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001223s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1006078 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000560s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1006078 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000616s ]