SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001286s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048316 LIMIT 1 [ RunTime:0.000361s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048316 [ RunTime:0.002085s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (709637,157893,550836,293912,669144,224260,491241,557970,792415,346775,392760,860372,99550,635821,78189,3158,849956,639419,702960,919740,641769,987919,304639,867705,1043560,918199,76362,49612,828947,938579,979154,532752,268564,335415,946091,852232,3027,668745,681179,726624,358777,744227,950928,260511,230554,543888,930385,511457,142455,203237,329510,35945,222463,515514,296594,364,664422,327403,647187,634465) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001295s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048316 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000752s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048316 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]