SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001340s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542934 LIMIT 1 [ RunTime:0.000363s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542934 [ RunTime:0.001809s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (634148,475060,267727,926134,226330,751506,397206,767311,521291,844825,282447,27489,949289,738021,722075,982882,701588,211202,424607,253109,298713,651718,594870,222421,240417,757704,267431,484180,641494,134307,21824,647855,381505,409477,579320,934677,450940,713582,611523,46096,635470,954292,81906,452550,260089,978761,177487,580997,399047,359033,466772,788013,698889,243424,518851,96983,207851,68015,877184,413212) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542934 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000395s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542934 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000497s ]