SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 330800 LIMIT 1 [ RunTime:0.000344s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 330800 [ RunTime:0.002020s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1008023,426830,88589,577898,889013,867872,158792,985053,212422,85740,571992,497364,313097,18493,882445,933808,241178,661048,200990,8469,361592,358028,497464,895887,612514,66482,698894,561883,315473,621586,175043,895456,790987,441668,878525,1037608,775998,780272,1042139,252140,298703,351331,60391,46742,551146,1039803,437150,839322,767365,693028,219252,446192,133323,663513,636538,895045,287732,835902,692945,105354) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001000s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 330800 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000361s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 330800 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001087s ]