SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001372s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 596928 LIMIT 1 [ RunTime:0.000367s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 596928 [ RunTime:0.001680s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (159166,171614,19091,825360,271341,934006,641036,1015386,986180,30073,933053,96295,836657,500245,600392,199265,813170,487606,96034,692977,562548,538990,4846,319124,395996,692309,618321,123909,792383,109358,281919,915570,477680,65040,325431,397360,714436,211108,902493,858985,486910,684360,171003,120166,992958,339005,901243,853840,434456,66530,240977,253168,230539,960232,210761,259005,108340,570094,558327,29172) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002188s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 596928 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001940s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 596928 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000734s ]