SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.004663s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 537821 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 537821 [ RunTime:0.006270s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (699010,216211,754088,242944,53750,606920,451520,917743,798819,293491,434991,940935,180659,740947,181028,143524,708283,262362,764174,691607,610701,69102,110980,455954,901337,266011,638353,616952,15743,286325,942751,245210,767047,65675,247229,596429,745514,490690,921806,326543,745291,823094,12110,763198,1042635,48671,1041027,57662,895471,617349,866241,64977,1009083,361860,91381,618120,43036,742793,549952,8612) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002528s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 537821 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000480s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 537821 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000499s ]