SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 243317 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 243317 [ RunTime:0.001899s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (822483,231343,284385,762383,1020163,205895,942966,94194,282290,817167,1021689,389724,483900,411012,77235,907836,864482,771776,428783,20131,844433,786218,1032102,384035,966936,850878,177067,169007,538121,874393,79755,43684,33660,368686,960807,78094,33768,3243,552100,329164,427805,260114,697017,929999,858417,380709,36576,737070,631310,248979,445810,377435,962385,527159,91455,270792,953887,582750,182680,901697) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 243317 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 243317 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000611s ]