SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001217s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 543311 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 543311 [ RunTime:0.004560s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (496838,51855,303981,986883,326106,863379,526564,332204,246473,1011679,194575,733845,927958,890540,330311,450299,1019205,391078,33491,60101,517964,984477,356735,542748,203041,484886,510437,228874,110790,223136,212745,462408,232427,471341,466607,692220,1030380,518049,539649,311121,319515,598122,390043,755723,819413,480214,66735,615448,964599,751389,957681,743830,807813,621596,929415,987795,770838,849026,992876,182699) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001554s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 543311 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 543311 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000710s ]