SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002313s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 549821 LIMIT 1 [ RunTime:0.003740s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 549821 [ RunTime:0.002703s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (156445,504908,558911,971277,949593,696943,999907,906167,170651,1013722,837810,574421,273643,12097,830183,661477,708131,466614,83561,723215,658615,6623,66497,404445,749119,763535,556093,423672,165192,575715,591608,432001,217246,122511,979788,539566,305338,82688,790268,310894,856465,435372,49599,981678,959397,980275,434069,514730,752797,162549,917054,122773,906544,413946,291682,56385,822072,346695,952993,817650) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 549821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 549821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000549s ]