SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001208s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 312688 LIMIT 1 [ RunTime:0.000441s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 312688 [ RunTime:0.002409s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (40673,77176,101081,119362,357876,280563,417912,297470,127931,929651,178925,834765,790488,102292,359039,718696,323852,155493,733982,548921,352919,37644,138197,1035795,509500,104068,1004724,942946,996514,62434,553450,50268,769243,365629,124340,230728,663419,654907,823955,362102,550948,995719,466443,321288,548971,444906,230900,961489,965752,493081,91963,593303,700192,306509,181914,486737,370695,302036,548198,645455) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 312688 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 312688 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000662s ]