SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001294s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 484101 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 484101 [ RunTime:0.001713s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (848089,643342,869943,341142,718003,353629,655326,928894,18708,625352,415194,556268,200760,275840,935144,965825,476607,292094,129073,405767,407288,132892,334358,101406,948628,450020,956153,831730,532505,390816,698192,641061,761149,790458,407318,785296,874844,944537,834558,47002,710436,395268,800667,732735,352997,757512,63432,382091,533920,945418,459489,198894,500347,486064,556291,919891,989892,1045084,355159,827238) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.011782s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 484101 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000493s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 484101 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001052s ]