SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001377s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402873 LIMIT 1 [ RunTime:0.000545s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402873 [ RunTime:0.002493s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (708124,868024,132106,540215,919050,1044251,262457,728106,78567,658934,445334,156461,165214,286568,35312,563094,330661,7714,811938,788356,170406,356030,238639,833779,825842,839363,328589,450720,875108,231280,802861,997584,234049,176519,495354,237961,221902,812160,923704,432584,682473,821288,210937,207223,633051,346118,992954,540157,102403,1018843,82300,735259,883710,98075,325964,504914,815314,831785,784595,952206) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001434s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402873 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000403s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402873 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000610s ]