SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001185s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1042817 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1042817 [ RunTime:0.002188s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (524191,463232,61757,514525,254888,269990,470257,1034391,95046,101157,16787,496199,551711,68262,560064,259308,233750,924766,833244,926987,162443,538587,67030,794222,659120,394410,432797,168223,387730,999479,119088,24670,555272,314545,879858,226104,659083,396445,647698,439412,505746,905606,11736,67634,966279,277188,890289,205048,440456,903781,355791,575253,258953,235225,499614,520292,548199,455629,592587,509780) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001297s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1042817 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000445s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1042817 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000620s ]