SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 267541 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 267541 [ RunTime:0.001758s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (366151,471868,124210,173425,593947,838061,942460,331292,345291,296977,136732,263046,997290,631784,79687,370318,363459,517559,602559,43764,993011,330429,5485,551327,507277,731014,221951,866610,350361,351012,506502,905144,521840,665493,864344,109232,818277,963878,772984,211203,972153,208739,304851,661969,252909,188959,413193,802675,666330,55384,56970,135794,515941,1035482,266927,854131,676562,566042,846114,82508) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001061s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 267541 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000394s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 267541 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000535s ]