SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 203383 LIMIT 1 [ RunTime:0.000401s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 203383 [ RunTime:0.001850s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (521125,766095,569022,225387,826642,856415,807753,963634,402020,1024161,797513,884175,472345,195471,270258,714793,70032,632169,597271,82505,965690,650546,300033,768792,526322,202989,594181,652050,143958,607361,733067,826449,178963,278404,49868,687942,807060,1015900,508121,776410,182061,654518,991782,792855,1047590,217962,36753,265890,712636,724268,9414,148899,295989,741362,823177,895470,31931,150820,481872,939352) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001306s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 203383 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000460s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 203383 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000729s ]