SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001266s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1022584 LIMIT 1 [ RunTime:0.000359s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1022584 [ RunTime:0.001636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (892011,430863,93351,340599,37825,936963,14525,872778,874882,259961,269535,311701,43125,88374,331588,629212,177172,550434,150798,780333,947885,791456,445233,996789,669649,411028,543704,151716,913721,894342,1017914,1046967,726104,782147,56854,69593,790721,368300,355182,87645,529600,868507,640222,568418,668266,962644,855531,830798,884576,3454,201494,1034427,237387,398203,319556,898804,4984,142868,970319,610607) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001017s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1022584 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1022584 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000490s ]