SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001140s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 663981 LIMIT 1 [ RunTime:0.000331s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 663981 [ RunTime:0.003323s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (880992,273860,86636,734936,46385,876106,458192,36931,183068,295005,547801,241589,252606,922385,1012880,628414,246276,36441,552291,448408,639287,394683,440326,854362,268408,228305,197207,482649,554902,842067,835706,939852,400555,47680,733719,105018,262048,883402,427214,27579,419000,169548,645023,435990,723424,242988,894747,483215,402503,680473,788591,1026576,528706,614469,677963,342750,650678,730907,863977,141070) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001075s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 663981 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000400s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 663981 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000694s ]