SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001308s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1001790 LIMIT 1 [ RunTime:0.000509s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1001790 [ RunTime:0.001582s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535629,623490,575030,1016019,411653,819491,843000,929197,679384,429342,148563,977518,511773,472140,578884,709752,114658,454312,37690,794289,410624,866242,533800,637497,467038,699577,737627,675812,684759,707627,603982,864269,813677,205575,926423,491677,168220,564389,858536,1024046,836626,671717,182711,25741,561297,347221,454792,400757,164735,409622,912674,864960,594396,434737,672697,358151,420763,8706,340195,345054) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1001790 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000657s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1001790 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000788s ]