SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1019071 LIMIT 1 [ RunTime:0.000417s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1019071 [ RunTime:0.001898s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (820963,917519,1006199,265636,144390,532878,655107,864027,769435,82696,254688,338521,13029,914445,1044981,653971,123018,643381,124279,874943,43624,252638,932928,994938,895477,664640,598384,284334,4559,858865,950883,298861,341644,549430,494395,514409,673898,578463,708938,181115,832340,467933,431968,261569,994752,590099,592045,1016705,923646,867665,836767,656000,741471,766274,384715,991615,775075,66,806644,688966) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.009445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1019071 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000602s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1019071 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000929s ]