SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 580818 LIMIT 1 [ RunTime:0.000324s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 580818 [ RunTime:0.001871s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (470635,850843,697156,860678,427401,564089,93954,460767,955297,15749,860402,89867,118798,148507,636310,347522,57860,597217,569304,720553,358104,551159,464221,59691,678033,1034897,61369,547872,262798,524164,871156,768140,126545,481155,795517,123668,151848,230284,77058,853128,648214,845843,45387,527179,620498,38928,151451,601386,716968,1001459,119842,30508,214015,46252,806247,848580,886106,599761,569164,453164) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000965s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 580818 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000339s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 580818 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]