SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001326s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 405305 LIMIT 1 [ RunTime:0.000539s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 405305 [ RunTime:0.001611s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (954875,986861,263620,934060,194014,240951,409685,977250,399643,436103,33635,657869,393841,477598,854515,608429,808724,664250,658545,810555,169313,998507,326568,502481,554759,932009,687911,1002560,878866,361883,60695,494100,402615,80119,1015528,350277,948203,89256,213722,152838,229284,269473,1025816,216797,170222,947905,712067,747836,898587,968615,1028618,619613,225550,887000,743766,15795,784155,583126,374183,846222) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000978s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 405305 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000340s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 405305 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]