SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001375s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 42122 LIMIT 1 [ RunTime:0.001869s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 42122 [ RunTime:0.001670s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1021232,249958,167357,838679,782448,237740,747610,430039,442734,394717,324089,980662,41109,1015117,231098,373192,481068,231629,508311,408476,935247,63867,598176,89975,1008898,461247,635501,879005,338016,26728,938804,126892,858109,786851,123341,311425,303960,600804,534534,1029524,172744,155425,565842,532017,910215,175338,707978,365559,528105,96993,554455,106639,467357,277033,164290,406206,720309,599274,655551,648427) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001449s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 42122 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000463s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 42122 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]