SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 199003 LIMIT 1 [ RunTime:0.000398s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 199003 [ RunTime:0.002956s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (280514,823663,672242,96026,425102,10075,906676,192277,712552,991120,847023,257734,1023985,601305,352795,381640,929476,661475,477054,149048,127708,662512,119748,460472,196625,62017,404788,1030489,460947,235426,558841,520762,971592,708409,777101,925864,583678,130935,392959,44576,239795,971132,965517,1044401,458007,279578,377267,983768,920327,694424,895031,814948,313905,797236,452167,884706,397573,872927,1001893,492249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001184s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 199003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000409s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 199003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000557s ]