SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001135s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 172518 LIMIT 1 [ RunTime:0.001209s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 172518 [ RunTime:0.002078s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1040145,570113,109708,887182,606308,1028059,938225,531823,281134,909043,69206,150874,288875,141436,771468,100678,873325,826064,153673,96407,354099,929310,504008,224027,579083,528574,515596,801767,188701,552745,206253,9956,838927,750625,353393,268840,83738,865744,1018037,148778,237787,516301,771649,217223,159262,301047,941376,117071,170713,871999,908151,982093,1005919,467616,157622,682089,681917,509157,293910,547249) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.028929s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 172518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001060s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 172518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001633s ]