SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 532986 LIMIT 1 [ RunTime:0.000400s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 532986 [ RunTime:0.005423s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425987,720934,345250,461362,686209,128310,798072,60198,324983,1036177,944575,151450,841845,732270,11244,709185,777671,722901,34950,484224,811699,495367,443875,1036726,134190,825448,41778,922837,275027,355998,828766,489660,23669,373538,108040,414277,782911,612736,522474,812732,578907,611213,191742,929092,856346,721166,776040,849921,165754,500888,27375,402617,863142,931036,91569,794724,967169,493413,107669,934730) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001104s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 532986 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 532986 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000511s ]