SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001145s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 523441 LIMIT 1 [ RunTime:0.001233s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 523441 [ RunTime:0.001644s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (235812,34510,720170,505758,360869,431236,554548,822244,327882,600474,381449,529904,502665,1003302,949941,956036,130845,839871,952254,413051,531171,348083,935046,733363,858206,1013741,816905,244481,55608,53574,453771,464682,278447,528108,765035,760035,845829,832653,716832,898975,37599,832222,64893,3194,84297,27638,77540,591608,922147,652234,350028,614848,657297,507604,950142,722433,548297,691212,97613,364835) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001044s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 523441 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000443s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 523441 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000760s ]