SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001168s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 10551 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 10551 [ RunTime:0.004093s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (69787,708241,997907,217016,463038,641449,663763,648006,316421,786741,697500,24003,474561,847650,409969,776559,363675,514797,85555,761224,458757,559172,339343,351715,385561,211799,112823,472894,831324,503778,672492,607749,169385,608516,331802,939086,89518,111681,787784,949054,257364,498781,957009,964258,88828,727230,448100,986013,244738,866219,1004066,287645,636755,848000,959069,26219,532233,793431,214689,977890) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 10551 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000439s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 10551 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000570s ]