SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001122s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508611 LIMIT 1 [ RunTime:0.001084s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508611 [ RunTime:0.001575s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1037339,843859,500807,145348,778763,845227,431177,278021,946727,14332,498751,360203,573050,1026153,650904,205859,947709,163171,161593,18311,505553,921325,1022067,567450,896323,359531,232270,334330,375970,95635,972287,822209,671107,996080,667380,140896,375810,167263,8667,135052,1003816,739605,920341,278938,814252,128564,989847,506065,1044855,81555,525030,850704,628767,470328,247390,975179,783953,899405,898788,679545) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508611 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508611 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000349s ]