SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001439s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 459674 LIMIT 1 [ RunTime:0.001670s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 459674 [ RunTime:0.001985s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466350,611553,461791,1022754,674488,615470,952063,42294,257858,921392,949390,891974,501172,75515,924060,752153,348386,187394,822998,811285,388867,823866,816217,235622,544084,749198,331939,413066,152371,355409,466082,772175,496559,406054,529908,817313,547622,455515,848277,753737,304117,503527,590183,875064,72403,145454,562790,71989,190033,483640,289825,573608,844007,181917,351454,811080,347280,593736,712448,952897) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.030761s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 459674 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000957s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 459674 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002544s ]