SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001196s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1005176 LIMIT 1 [ RunTime:0.000407s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1005176 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (104417,730143,68354,495840,584978,369654,656851,193305,255171,379315,297815,295499,469086,311025,825953,347428,430897,559283,68804,865711,219336,797168,826150,1037521,178742,19732,951692,578189,398286,1038354,811855,195689,163965,588004,863922,775710,966489,1007688,153757,201224,722235,131439,360719,367965,996473,921365,905359,204781,693998,658848,221522,394698,700073,168958,668949,955670,85677,478907,441641,865320) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000941s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1005176 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000321s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1005176 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000525s ]