SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001893s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009026 LIMIT 1 [ RunTime:0.000446s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009026 [ RunTime:0.003189s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (459982,326104,308401,708590,448981,54192,424425,229682,940861,173220,121091,446654,677827,879936,669056,552968,70492,51790,978872,516050,863360,653176,610879,644608,350077,476347,100838,299671,596332,526392,395053,78264,770157,507849,753625,572574,16043,872243,452115,920149,155415,6388,739439,972932,94995,777185,764004,443217,716628,771057,268797,716257,971417,704250,1024650,19782,415852,93941,374504,236275) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001268s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009026 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.002539s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009026 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001344s ]