SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001221s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539518 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539518 [ RunTime:0.003503s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (472031,178813,64733,596005,753788,746807,907867,391064,864476,744671,308922,138957,967540,553095,51965,284999,108817,607428,54146,705581,379536,221563,930459,442435,180355,79239,865502,744932,220860,672518,196354,814802,152923,763020,298016,93766,665288,900250,999196,952700,291395,335887,150386,678117,1013742,323023,640863,354375,866269,315106,956099,485246,955182,805874,645824,195267,933644,18779,571277,209658) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000931s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000776s ]