SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001249s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 534743 LIMIT 1 [ RunTime:0.000581s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 534743 [ RunTime:0.001824s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (298903,785835,717422,500348,935720,182770,89904,675858,409418,942164,486340,628305,510780,420034,568536,643751,982877,602039,655157,439625,404335,101353,504395,914589,420826,472467,55063,771796,407203,194176,228335,111930,643624,131182,390223,11544,725309,381187,752722,690426,782870,146318,194897,983289,255561,1010229,184575,219686,535508,228888,857759,762501,765630,238770,214295,938053,819596,973626,494312,87826) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001174s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 534743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 534743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000697s ]