SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001127s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 508263 LIMIT 1 [ RunTime:0.000335s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 508263 [ RunTime:0.001522s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (256216,507490,1015593,424505,534280,192864,982001,466417,603432,104392,579010,1034417,68343,251385,640894,815006,80069,510345,18000,624901,812679,315025,436002,355820,300795,957068,754981,393398,361955,589292,507091,943356,899215,934514,168863,815736,805450,328066,900984,465383,398068,898443,575896,668920,777329,33705,402076,267391,98030,791998,639473,519258,206593,385416,816941,787402,460889,33718,910661,691894) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 508263 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000370s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 508263 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000551s ]