SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001403s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504527 LIMIT 1 [ RunTime:0.000378s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504527 [ RunTime:0.001830s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (207655,299283,59871,568820,157211,816404,856078,1046120,4713,424031,361507,739184,384620,158905,926450,713434,764181,496442,803137,374358,522347,884001,183503,357393,835194,397040,589481,951551,459967,497340,517049,623236,637076,952578,800578,439634,885091,385568,717503,99538,428164,721873,443318,615162,33403,52316,375122,634626,376748,426270,377030,597983,380293,338276,279404,551299,54389,647889,210351,994141) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504527 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000387s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504527 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000664s ]