SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001245s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 529003 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 529003 [ RunTime:0.001593s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (483351,879360,405039,414192,167455,237214,790884,754663,597410,1042025,458167,507663,649480,593549,954808,96163,729592,830631,1029515,505861,212520,754420,40190,767214,349098,6956,693660,745455,376063,821892,810753,1000233,900901,141974,789704,165480,447339,862770,903658,47019,441407,936531,659929,425075,1012300,634260,998582,594747,715701,928333,341594,540630,440631,38009,86572,425815,477114,742088,595899,329357) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001074s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 529003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 529003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000576s ]