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` = 2854 LIMIT 1 [ RunTime:0.000404s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 2854 [ RunTime:0.002540s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (687718,412713,1037875,53236,1013546,206477,433533,138327,1009009,776729,191473,775780,378395,91357,181240,461104,583387,880929,284373,799177,959506,961449,286118,253857,922968,463618,604139,1023636,545113,608417,1008642,270547,1007674,125167,1015030,349499,76828,608872,988734,892341,200227,420014,539691,504538,115492,699342,116706,40843,910031,540105,1034500,980947,5658,50605,961587,579678,598909,956573,873865,671198) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001046s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 2854 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 2854 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000550s ]