SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001556s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 396911 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 396911 [ RunTime:0.001832s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (193812,648187,571529,508627,793475,475599,195528,835000,999327,599380,926494,237935,514715,19736,840903,205351,681049,875934,523462,577911,769501,739488,525404,134529,1042838,373062,613469,222140,876780,1000862,861442,163653,630583,238982,817320,959319,956879,413132,863701,530244,181588,382060,201466,219218,1005304,956706,34300,690936,393055,879996,282497,515578,120909,139346,575626,543693,1001393,1025288,618052,56286) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 396911 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000610s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 396911 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000756s ]