SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001155s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480214 LIMIT 1 [ RunTime:0.000403s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480214 [ RunTime:0.002730s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (855969,509062,927582,758833,643224,778139,254007,683186,100016,930327,997237,992052,882292,509698,50811,950786,200143,830174,952340,372808,486101,570181,111911,657164,841663,11328,975035,346168,994384,70229,206497,1034113,312612,82146,134311,692298,354836,22543,12675,578388,925347,78770,812425,870574,1022675,1041795,201968,221788,133898,1007233,941149,260284,843231,990284,507100,572296,1006278,129033,856612,255944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480214 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000846s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480214 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000443s ]