SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 421015 LIMIT 1 [ RunTime:0.000452s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 421015 [ RunTime:0.002846s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (397820,492138,849685,1029424,958699,1008185,643836,872027,341268,869707,110545,549129,227967,644724,443849,1000759,235551,684694,160981,580833,501881,61691,490589,698619,278590,379760,457433,157555,359295,998231,907917,554159,109683,704302,401928,724932,383800,869621,210093,415059,67804,193669,649174,32960,743949,898631,429754,632791,953551,456853,383356,312076,204943,539877,529546,108549,517906,29640,866322,58811) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001118s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 421015 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000378s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 421015 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000626s ]