SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504794 LIMIT 1 [ RunTime:0.000341s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504794 [ RunTime:0.003533s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (435397,915003,957734,970992,356463,738682,380961,113417,33704,504487,576670,336237,694461,849884,251944,649154,305988,831243,418396,495276,102292,425816,859821,360425,776794,728613,859326,445147,275789,222476,457396,440710,205394,339451,99574,549569,983704,720370,762298,508971,595236,814420,1012977,243438,159222,643796,748654,416659,453370,1186,544989,897072,449049,159210,977546,86162,1002054,395655,824398,437746) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001105s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504794 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000356s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504794 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000467s ]