SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001158s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004775 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004775 [ RunTime:0.001425s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (546809,1019377,587203,428171,279981,737068,788006,326131,366976,179225,500257,1048922,28833,364045,100669,787401,424228,40929,582319,168219,562236,323465,722136,905786,121621,198568,963775,330785,462792,514921,407600,497670,212685,592347,965209,525896,901445,180912,489422,92841,296557,653360,433416,138180,555932,151,60652,658890,525408,248332,757894,1000163,326509,599787,742434,240267,640022,541747,992732,176491) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000944s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004775 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004775 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]