SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 193851 LIMIT 1 [ RunTime:0.001611s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 193851 [ RunTime:0.001621s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (117859,625519,885388,293593,946354,634377,185590,761452,419281,689325,342056,424770,580368,36891,721455,895626,50334,75384,367412,450088,210258,104969,865439,1000026,22647,1007570,852661,693826,757557,108908,1011371,761981,1035105,183869,753453,641539,101345,560676,919381,317524,879325,687532,198002,894657,7748,1018786,648572,1001457,1000730,195414,352817,469041,108220,849444,992206,414677,311608,669361,800108,627798) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.006368s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 193851 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000502s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 193851 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000518s ]