SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001432s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 3919 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 3919 [ RunTime:0.001876s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (267174,395422,851579,623808,901533,673476,1021087,512761,493190,179068,917460,437244,378385,608239,520411,223527,964446,415467,81489,844258,793401,165937,489324,463042,86322,1031673,882280,861799,953232,759788,312419,782865,590258,703313,462667,496564,235307,11991,509620,670803,977369,388618,357423,277084,45197,723123,846712,154422,842732,305332,550191,29620,143234,876562,939093,378971,101966,75140,903504,1029089) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001358s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 3919 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000374s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 3919 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]