SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 489211 LIMIT 1 [ RunTime:0.000355s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 489211 [ RunTime:0.002068s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (605071,1007272,178434,525677,383916,652421,848924,660786,560335,549068,561775,920886,1002056,1030111,703975,39975,351449,639816,490848,407924,524751,901979,787305,359017,347265,545064,971647,445089,225658,227137,624098,643988,113581,607310,811790,240754,595105,796642,97632,677220,952315,389506,197220,367481,198009,695505,1043257,1037754,666310,45999,731005,750850,695948,248743,402631,359133,640134,475843,161164,321410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001234s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 489211 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000398s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 489211 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]