SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001106s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 490087 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 490087 [ RunTime:0.002475s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (50209,140040,1035892,139611,734111,38631,541703,342509,908105,718744,578357,294551,474815,869258,1046933,930663,904633,585626,572732,549714,31455,727456,945524,568671,783117,846616,184399,137453,61978,1025655,483097,326640,979469,379316,54139,12260,350354,64319,530416,767309,682045,256536,920991,139435,107009,280817,1026372,762310,640299,373554,382077,283038,328457,54446,319100,268010,178069,763021,528586,277283) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000988s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 490087 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 490087 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]