SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001193s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 447604 LIMIT 1 [ RunTime:0.000350s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 447604 [ RunTime:0.001707s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (427529,184197,664921,833022,315327,152597,36577,101869,437741,69640,689551,322894,737691,353444,503403,988011,243736,153739,968465,59366,867884,221453,174574,944020,794183,794706,956168,699611,194334,312386,714167,1009771,675473,572258,407210,859843,529748,938769,853516,469721,716117,167551,135869,371234,1021078,783989,656889,755997,201272,550381,373783,298068,479050,1042110,254634,358637,743510,540712,892725,830945) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 447604 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000417s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 447604 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000568s ]