SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 401029 LIMIT 1 [ RunTime:0.000298s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 401029 [ RunTime:0.001543s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1015135,139337,335051,830861,324941,904894,372382,1043127,559115,395881,982059,318926,922093,310599,528725,1048207,883372,366482,369791,947,1012948,922334,650175,992531,506577,633990,392892,446579,328174,596458,370409,942552,562994,928416,657575,212759,192524,594374,560312,782001,683102,503107,687279,34688,756521,939380,941964,561326,108588,893496,668628,319062,190250,301535,1023050,1038020,472172,787171,859149,283708) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000981s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 401029 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 401029 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000545s ]