SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001356s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 555916 LIMIT 1 [ RunTime:0.000419s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 555916 [ RunTime:0.002184s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (805482,108428,1016557,296458,1005972,806899,457165,615104,737364,659191,851232,346815,510427,616825,21115,30980,858086,608705,778528,867607,136090,283165,28757,137385,422175,639694,384473,766341,249924,774898,643722,650874,100451,403987,68527,14163,197398,614400,724948,769879,958755,344697,290230,4466,126974,144380,95026,586253,800432,216889,550448,390932,207706,965843,336645,962995,885543,323018,434542,467071) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.014269s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 555916 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000536s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 555916 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001025s ]