SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 801312 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 801312 [ RunTime:0.001763s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (741911,171673,801919,692338,441094,372318,50861,428717,781164,777954,361848,451856,897450,994559,863915,194274,750251,1023703,34690,118754,835573,440287,700277,420647,864393,351278,941159,480974,387788,74461,1040620,224834,603140,609101,659879,215763,1032965,590949,779858,860439,263029,950235,791351,1018360,305780,929936,706774,888341,383421,244916,93681,532651,992547,35538,542782,355247,617684,67332,1011372,71083) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000973s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 801312 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 801312 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000621s ]