SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001977s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 453103 LIMIT 1 [ RunTime:0.000573s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 453103 [ RunTime:0.002129s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (10137,425206,641065,14212,1035215,259467,365981,165926,542363,473661,193769,400555,430099,892387,89248,934230,428978,910789,366550,430292,112690,402445,317925,775213,761105,899326,737620,585811,551240,931961,1015595,857028,80978,630870,1021145,535636,209564,414060,669987,477128,30603,463206,922558,210190,327941,795962,507261,1019834,374152,946297,429757,575060,882014,1015425,174566,986080,1031804,738653,657869,375638) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002912s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 453103 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000572s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 453103 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]