SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001300s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 36143 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 36143 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (891241,257812,927734,596947,693783,843297,144817,158997,803805,137281,199280,442442,660654,548597,902805,122645,317575,243462,841700,459400,828884,461934,823998,208886,717614,848006,179555,882696,873865,760024,42079,203029,456299,145594,1048574,275028,122352,33926,994707,695011,557554,106071,673461,917631,873481,1021641,858838,1042199,930894,668578,829826,206448,129051,686199,454011,941968,745956,114113,591212,138410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000946s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 36143 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000901s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 36143 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000521s ]