SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 443627 LIMIT 1 [ RunTime:0.000424s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 443627 [ RunTime:0.001980s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (420030,810166,122185,273731,170892,429467,608332,972739,167152,1020358,807596,864005,510895,853873,234152,22969,905163,83686,664167,369731,286746,880781,883866,5568,465860,928300,589692,83571,868156,52080,104987,362483,764310,807451,901656,154402,423756,383275,866312,885015,531804,423976,819466,588554,790145,738533,611494,804373,246821,583368,291319,218514,819875,292978,923567,349220,191736,137927,951561,509548) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002653s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 443627 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 443627 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000553s ]