SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001470s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 411460 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 411460 [ RunTime:0.001829s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (26211,562632,66821,925810,534649,775045,521100,360372,908290,463800,195530,482713,51397,742525,56165,1026553,493171,574756,331897,72244,474489,308803,208184,121508,198677,171149,51449,531838,189729,788831,165763,992792,37222,23294,372018,557231,754638,555514,94229,68664,534971,703573,624650,570207,990472,103479,915220,258698,511139,406061,88542,734352,429271,695779,149479,678788,570663,708988,531343,312448) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 411460 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 411460 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000582s ]