SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001281s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1026120 LIMIT 1 [ RunTime:0.000369s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1026120 [ RunTime:0.001516s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (582281,891442,50016,951291,504812,482256,510409,462391,950432,541991,326776,457458,98572,947841,94481,659418,528353,1019048,243730,53933,812879,335376,713446,1047127,242715,583389,386959,269953,699921,746076,152499,892926,842931,672052,381928,745762,14845,1032306,122825,460739,417974,188920,865377,253721,1005735,178264,661535,108141,716407,57891,626337,678360,947570,30072,769666,368411,520580,290570,415146,332222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1026120 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000430s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1026120 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000394s ]