SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 139500 LIMIT 1 [ RunTime:0.000479s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 139500 [ RunTime:0.002062s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (79225,1047688,62496,1009033,838481,366518,542832,1003591,916050,265246,919225,282135,821837,326041,187615,83878,750890,675592,1027053,102722,123538,864130,674108,988841,992399,850899,495928,809197,506602,918643,86355,56305,1015558,279618,587183,1008749,911117,811492,908253,499310,86815,866419,945392,845979,308609,235338,620236,595487,693561,728165,335496,1008548,662570,162245,911433,709304,455431,71024,1008035,986039) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.018926s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 139500 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000532s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 139500 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001960s ]