SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003374s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 287639 LIMIT 1 [ RunTime:0.000302s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 287639 [ RunTime:0.001065s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (796649,542382,365793,191542,149738,492632,584037,105553,11548,25818,1012463,1043151,385912,814529,368552,381096,1042808,890058,1020295,938973,608158,655095,624467,78211,931079,149559,505681,826093,815117,133571,627803,844420,136188,707689,431794,152430,496994,466251,252106,637112,834452,912580,878967,1003586,796628,398812,819307,168619,533906,134256,376663,31530,452225,134841,508127,26200,733007,279525,953913,763185) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001031s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 287639 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000379s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 287639 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]