SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001256s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 807228 LIMIT 1 [ RunTime:0.000399s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 807228 [ RunTime:0.001730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (365401,640031,146085,573658,305787,342060,101040,524024,262137,199541,453278,795039,685781,775154,889389,227083,200780,537337,774266,148265,471666,576951,256096,545089,1017730,161698,832102,83041,390867,573516,262859,298713,405319,357598,591158,640463,134451,437278,648936,934889,86034,715844,373312,661346,478710,359903,980593,652189,460854,421386,754821,751848,431270,384868,267233,716342,751515,504925,745424,678015) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 807228 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 807228 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000558s ]