SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001197s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 819688 LIMIT 1 [ RunTime:0.001785s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 819688 [ RunTime:0.003193s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (484440,717194,671905,710963,678475,1028981,12862,1023985,1036187,943522,762292,870916,865858,361042,513886,528134,3966,176040,1027902,776849,267155,686700,210395,1003706,504717,393027,583766,953817,954793,571923,756505,814270,1010147,11951,143428,131981,256317,439341,842642,590019,563082,235965,304881,462877,717288,757895,1028665,643661,334899,171814,25040,848318,283834,61540,501619,588387,75808,702420,530554,493458) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 819688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000414s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 819688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001982s ]