SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 782070 LIMIT 1 [ RunTime:0.000352s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 782070 [ RunTime:0.002164s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (778105,780666,682394,1017596,89536,327253,887275,52590,605078,83488,630401,1025911,964846,356791,381452,255945,281962,1016476,524337,785133,411842,126781,999611,102694,85469,761179,304522,1019824,450874,394145,445505,112023,403629,783354,501283,365295,978812,632525,966395,458140,217509,543341,294664,102359,809558,364081,712988,147983,203482,481546,49997,365639,97301,318997,211893,284289,16475,141428,1015118,35152) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001722s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 782070 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 782070 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000533s ]