SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001619s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1047892 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1047892 [ RunTime:0.005808s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (928622,320867,669403,914911,360994,992705,461924,370869,42183,598285,314365,163460,549174,803334,899749,940025,949731,403035,458454,404766,701838,1018313,944377,352733,855448,101324,689600,766188,816523,672023,173747,472829,338351,325401,40772,130494,409185,111837,943852,757021,668057,229746,447562,199653,621953,468190,906051,659859,807782,402981,397056,515336,178991,152574,291728,851528,114570,909164,681617,529254) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001531s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1047892 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000489s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1047892 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000537s ]