SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56335 LIMIT 1 [ RunTime:0.000753s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56335 [ RunTime:0.002218s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (905145,476947,334444,687307,871656,938421,307634,745292,270944,281942,783334,1001069,386088,31978,324861,52984,136504,364679,415201,647781,412549,690309,118349,237632,130540,681291,166314,249813,303242,262380,1005277,962564,184047,248546,592876,623668,929651,618078,261043,63804,362756,406451,60759,78351,775191,809060,1045330,1043510,714431,362232,173045,130423,1048404,23174,659509,1012539,953570,240451,244291,955010) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001070s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56335 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56335 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001426s ]