SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001573s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 414351 LIMIT 1 [ RunTime:0.000408s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 414351 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (603912,994290,663587,119928,676960,1007095,1032265,727151,226694,910125,1005939,893938,929017,455233,637797,399451,313544,353273,461247,875266,156047,340404,786733,600799,255586,1034160,395542,698483,196380,731573,815711,473253,946385,763989,79266,803130,269838,384288,252329,2889,78357,509193,690421,578279,305637,577959,957065,826504,762761,373221,591488,386689,225626,81311,501320,659981,31824,1033225,180959,1016626) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001211s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 414351 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000363s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 414351 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000726s ]