SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001030s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 213844 LIMIT 1 [ RunTime:0.001850s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 213844 [ RunTime:0.002773s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (505956,613739,138077,882390,195984,784062,777497,1042660,709234,409834,789563,72155,993826,724648,890550,112054,780547,339695,719232,894593,986852,760452,74924,592116,70748,871408,27823,33,623187,57812,208246,872169,390744,689113,799703,951108,1002355,773028,991156,801815,934021,215408,33785,642970,636350,393341,1046,885193,118481,250770,540719,965970,357638,766438,680819,754360,149806,253878,710195,14912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 213844 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000484s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 213844 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000974s ]