SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001203s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 480615 LIMIT 1 [ RunTime:0.000430s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 480615 [ RunTime:0.001787s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (904110,158448,1027542,328973,20198,58609,524989,227998,187031,856330,301211,942396,509012,958372,170247,617164,585966,669403,560175,524245,636879,899792,270203,196533,261847,733,229951,414759,976025,142338,285076,441919,668597,538397,496297,109168,592968,90188,126609,12021,672480,1019534,836915,40571,75740,192772,988514,612929,330987,18605,200498,811834,730298,668771,617635,622989,344257,43252,775565,699673) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001312s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 480615 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000524s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 480615 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000600s ]