SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001875s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 201453 LIMIT 1 [ RunTime:0.000364s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 201453 [ RunTime:0.004168s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (665098,335116,552909,269430,219713,104046,562318,843806,888155,826932,58734,1006035,422762,653128,350434,198768,81894,950312,277511,325539,465969,588214,890466,899139,174373,570779,858335,850400,823058,1042619,866629,573895,211362,970978,857224,767703,774912,338168,547964,448701,326491,67551,370603,179765,671586,921701,181378,974507,867067,574179,399187,609645,346880,929017,114056,499131,793065,774899,46522,578094) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 201453 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001035s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 201453 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002058s ]