SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001472s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 454095 LIMIT 1 [ RunTime:0.000599s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 454095 [ RunTime:0.002485s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (228179,259426,197951,888050,205805,319630,226384,174660,217863,601312,438739,451625,549277,751306,654986,970668,1006063,731035,373745,398806,382134,935125,303100,993716,51780,27342,705400,365676,588709,269476,225407,886644,854667,127977,302445,19346,410399,380961,710087,613270,182076,828994,879921,480634,397654,677424,473504,347767,348133,532046,1034142,366782,926314,609973,633745,57907,423720,479611,75499,639917) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001042s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 454095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000366s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 454095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001894s ]