SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001990s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455104 LIMIT 1 [ RunTime:0.004006s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455104 [ RunTime:0.002101s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (533327,848076,596422,483169,614724,653235,664324,456433,1029580,309371,958828,106792,663305,922301,698998,755481,786681,1034883,24899,831790,771307,223877,354767,907673,189102,780133,41425,432286,147130,96313,138076,482445,51911,321629,567380,579731,709616,774070,50779,396401,988738,8621,950419,40612,111993,276792,655782,933873,807241,503736,1047360,596749,722944,1023660,170006,585082,413992,581615,661754,96364) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455104 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000384s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455104 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000599s ]